﻿CREATE TABLE [acms].[UserPostUpload] (
    [Id]           INT            IDENTITY (1, 1) NOT NULL,
    [UserId]       INT            NOT NULL,
    [PostId]       INT            NOT NULL,
    [FileId]       INT            NOT NULL,
    [Title]        VARCHAR (500)  NULL,
    [Comment]      VARCHAR (2000) NULL,
    [IPAddress]    VARCHAR (16)   NOT NULL,
    [Reviewed]     BIT            NOT NULL,
    [Reported]     BIT            NOT NULL,
    [Suspended]    BIT            NOT NULL,
    [Deleted]      BIT            NOT NULL,
    [Created]      DATETIME       NOT NULL,
    [TextFields]   XML            NULL,
    [ConcurencyId] TIMESTAMP      NOT NULL
);

